2018-04-26
Figures
Tables
| Site_Desc | n_species |
|---|---|
| Anacapa Island | 28 |
| San Miguel Island | 42 |
| Santa Barbara Island | 30 |
| Santa Cruz Island | 77 |
| Santa Rosa Island | 166 |
Declare Function to 64-bit Private Declare PtrSafe Function using MS Access 2013Windows only connection option:
library(RODBC)
accdb <- "Z:/bbest On My Mac/Google Drive/projects/nps-ecoquants/data/CHISLandVegetationMonitoringDatabase/LandVegetationMonitoring_DATA_be.accdb"
odbcDataSources()
db <- odbcConnectAccess2007(accdb)
sqlTables(db)
sqlQuery("SELECT * FROM tbl_Locations")
Connect Access Front-End to Postgres Backend:
Assistant applications to handle conversion / synchronization:
For example, with Shiny:
Working with databases & Shiny:
From the same Rmarkdown document:
You can generate these (and more):